Hello everyone, My company has provided me dumps of excel data which is in the below format, All the records are sorted based on company but the company field is not available as you can see. I need to transform it as shown below. NameCompanyIDTeamStart Date TimeEnd Date TimeAkashABC Software Solutions10Admin27/07/2021 14:0426/07/2021 17:54AniABC Software Solutions20Software27/07/2021 14:0426/07/2021 17:54ShankABC Software Solutions30HR27/07/2021 14:0426/07/2021 17:54HarishZZZ Hardware Solutions40Hardware27/07/2021 14:0426/07/2021 17:54HarryZZZ Hardware Solutions50Hardware27/07/2021 14:0426/07/2021 17:54RajMMM Labour Solutions11Household 27/07/2021 14:0426/07/2021 17:54RockyMMM Labour Solutions21Household 27/07/2021 14:0426/07/2021 17:54 Basically I just need to get all the company names that are provided as header to a column. Please share any idea or tips to achieve this. Thanks,Karthik

Anonymous Pls see the attachment below

Anonymous

Not applicable

5 years ago

Solved

How to manipulate data as shown in Power Query

Hello everyone,

My company has provided me dumps of excel data which is in the below format,

All the records are sorted based on company but the company field is not available as you can see. I need to transform it as shown below.

Basically I just need to get all the company names that are provided as header to a column. Please share any idea or tips to achieve this.

Thanks,

Karthik