Jun 09 2021 05:10 PM - edited Jun 09 2021 08:41 PM
This is a simplified version of my sheet. It was one of the excel sheets that my ex-colleague created.
Currently, there are two behaviours that I couldn't explain and it's confusing
FY,
1,A
2,A
...
If we leave the first column empty, the correct CSV should be
,FY,
,1,A
,2,A
...
1. Does anyone here know what might cause this behaviour?
2. With power query, is there any way to pull my data by ignoring the first column which is empty
Jun 09 2021 06:23 PM
Jun 09 2021 06:31 PM
Appreciate your response.
I am not quite sure about that but when I have this (I didn't put "")
What I got when I downloaded is as expected:
,FY,
,1,A
,2,A
...