PowerBI table transform

[hpatel123]

Hi, 

i have a table like above. How can i transform this to something like below so all start and end dates are consolidated to two columns? This will help me build my xviz gantt chart.

[hpatel123 · Accepted solution]

disregard my last question. i was able to figure it out. i created another custom column to T&C, SPC1-2, and SPC3-7, then pivoted the columns, which worked!

[hpatel123]

Thank you amitchandak. Your steps helped me a little to get closer to where i want to be, but not there yet. Below screenshot shows Start and End dates date showing 'null' and additional unnessary rows.

below is 'From' current table 'To' my desired table look on how i'd like to see

[Ashish_Mathur]

Hi,

Share raw data in a format that can be pasted in an MS Excel file.

[amitchandak]

@hpatel123 , step one unpivot all date columns.

Step  2- Split by a delimiter, use option first delimiter in power query (There will 2 columns)

Create a New Column in power query

= if Text.Contains([Part 2 of split], "Start)  then "Start Date" else "End Date")

Delete the part 2 column now 

select the new column with Start and end date and Date and pivot that

https://radacad.com/pivot-and-unpivot-with-power-bi

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

Pivot Data(Power Query) :https://www.youtube.com/watch?v=oKByyI09Bno&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=12

Text.Contains: https://youtube.com/watch?v=Hs2q6qcrdgU&feature=share

Power Query Split Column , Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag

If this does not help
Can you share sample data and sample output in table format?