Forum Discussion
Filling empty header with content from other header
How do I do this in the most flexible way for header (as it might change depending on data size) :
Raw Data :
Name | Time | Email | Query | Column5 | Column6 | Column7 | Query2 | Column9 | Column10 | Column11 | so on and forth
Desired output :
Name | Time | Email | Query | Query | Query | Query | Query2 | Query2 | Query2 | Query2 | so on and forth
The number of empty header might change according to different data and I can't seems to find a good approach to this.
Link to the excel sheet of the raw data & expected results : https://www.dropbox.com/scl/fi/v2hm6dwidgunn8idl8eqa/sample-raw-data.xlsx?rlkey=jj2zpwh9zri3icz1nphr7lcld&dl=0
Thank you in advance!
2 Replies
Please create a pbix file that contains some sample data but still reflects your data model (tables, relationships, calculated columns, and measures), upload the pbix to Onedrive or Dropbox, and share the link. Please use Excel to create the sample data instead of the manual input method share the xlsx as well.
Describe the expected results based on the sample you provide.
Here's the link : https://www.dropbox.com/scl/fi/v2hm6dwidgunn8idl8eqa/sample-raw-data.xlsx?rlkey=jj2zpwh9zri3icz1nphr7lcld&dl=0
Thank you for your kind help in advance.
