Forum Discussion
Transposing Data
I also shortened the steps (optimized, not much)
I guess it depends on if you really ONLY have 3 rows with Column 1 as NULL or it is more than that, but you can do the following.
Create a second query referencing the old query, taking only the part of the table that has Column 1 as null and transposing that.
Then do various transformations in the first query
As a last step, create a new query "append as new query" and append the two tables, make sure here that your column names match (you can adjust them manually)
Maybe this gives you what you need to figure it out.
My point is that the structure of your rows are so inherently different that i would separate them completely, transform it so it will fit together somehow and then as a last step actually append them (put them back together)
Thank you. Yes, those 3 null values are the only ones in thet column. I think this is similar to what Greg_Deckler proposed (which is getting me closer but not completely to the solution).
Further, what I shared is a transformation of an original raw data source in an even more unworkable format.