Format Conversion

mihir777

New member
Joined
May 28, 2016
Messages
24
Reaction score
0
Points
1
Excel Version(s)
2016
Actual Data

NameTopicDetailsLink & AttchmentStatusStart DateEnd DateProgress
Raja in progress01-10-202025-11-2020
Rajb completed01-11-202012-01-2021
Rajc working05-12-202025-12-2020
Rajd not done08-01-202108-04-2021
Raje started20-03-202118-06-2021
Ronaka in progress01-10-202025-11-2020
Ronakb completed01-11-202012-01-2021
Ronakc working05-12-202025-12-2020
Ronakd not done08-01-202108-04-2021
Ronake started20-03-202118-06-2021


Output Data required

Raj Ronak
TopicStatusstart dateEnd Datestart dateEnd Date
 

Attachments

  • report.xlsx
    9.6 KB · Views: 7
Using Power Pivot and creating a measure for the Start Date and End Date. See the attached file.

Data Range
A
B
C
D
E
F
14
Name​
Values​
15
Raj​
Ronak​
16
Topic​
Status​
StDate​
EndDate​
StDate​
EndDate​
17
a​
in progress​
10/1/2020​
11/25/2020​
10/1/2020​
11/25/2020​
18
b​
completed​
11/1/2020​
1/12/2021​
11/1/2020​
1/12/2021​
19
c​
working​
12/5/2020​
12/25/2020​
12/5/2020​
12/25/2020​
20
d​
not done​
1/8/2021​
4/8/2021​
1/8/2021​
4/8/2021​
21
e​
started​
3/20/2021​
6/18/2021​
3/20/2021​
6/18/2021​
 

Attachments

  • report.xlsx
    181.8 KB · Views: 5
Back
Top