I have an issue with the Unpivot command
What happens in the Before issue that is the structure of the file that I get to Excel
There are 2 titles - the line 3 + line 7 GL CODE
I want to make the table long - that all the data will be in rows
So that all the cells I colored in yellow will be in one row
In the After issue I started running Query just failed -
What can be done to place the yellow cells in one row ???
Hi Lea,
I think you've shared the wrong file as there are no cells in yellow.
Mynda
This - highlighted in yellow
Row 3 - should be the title
Thanks for the answer Leah
Hi Lea,
Thanks for clarifying with the screenshot. You can add a custom column that says if
= null then [1] else null and then fill down the new column.Mynda
I'm doing what you wrote
Receives an ERROR message to all cells
It is also not clear to me whether UNPIVOT should be done
I would be very grateful if you could do it for me in the file and then I will understand better.
I need the number 30495 in the same row to be 60000+ the rest of the cells
Thank you!!!!!!!!!
Hi Lea,
Please see file attached.
Mynda
Dear Minda, Thank you very much !!!!!!!!!
You helped me a lot !!!!
Very appreciative, Leah
With your permission, I sharpen the question
The file I made here is just a sample of my large file
The updated demo file is attached here
What's Happening in the Big File -
That in line 6 of GL CODE there are other numbers besides 6000
In the attachment I highlighted another number in green
How now do I cause line 6 to flip along even if it is not a title line?
So the result will be - that in one row will be all the yellow + green cells ???
I had an idea -
I set row 6 - where the data changes to a header row
I added after the number which is 5 digits - _the name of the column
The column name is the salary component such as vacation, 1.5, etc.
I did a column inversion and split the double header that is now in rows - into 2
Attached is the file I made.
This step succeeded - but the problem is 0 I need to run it on the following files where the figure in row 7 can change
What happened to me that I changed a given and then he got stuck ...
How do you define a header line that will be automatic from the 2 cells - GL CODE + the wage component ??
Hi Lea,
I'm not following, sorry. It's difficult because I can't read most of what's in the file attached because it's in Hebrew. Do you think you could make an example file in English so I can see what you're referring to?
Mynda
