Power Query | Show Additional Column Each Day

[ovetteabejuela]

Hi,

I need help with the following and if possible I don't want to transpose the table because I know it's an option but I think there's a better way (that's where I need you guys...

FOr example I have a raw data that has 5 columns(in reality I have more), and column names are exactly as below

Column1, Column2, Column3, Column4, Column5

Today I only want to retrieve >>>> Column1

The next day >>>> Column1, Column2

and the next >>>> Column1, Column2, Column3

and so on...

How can I do that using Power Query?

[edhans · Accepted solution]

Check out this article on Power Query. Specifically, referring to columns by their index number, specifically the "Use Column Indices" section mid-way down. It may point you in the right direction.