Forum Discussion
Convert Table Sections into Columns
Hi Mat42 ,
According to your needs, you can achieve the results you expect in Power Query.
I did the following test, which can be used as a reference: "Reference" a new table in the query, and then do the following steps
Then create the index column and merge the table through the index column.
Finally put the corresponding lot on the table visual to get the desired result
Here is a relative link for referene:Solved: Filter rows in Query editor - Microsoft Power BI Community
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Mat42 so the data is always in these block:
For example:
1st block -> user 10 rows
2nd block -> company 3 rows
3rd block -> vehicle 8 rows
so you will take a first come first serve row from company and vehicle and link with the user, correct? so first 3 rows of users will have company data and the rest 7 no company data because there are only 3 company rows and then the first 8 rows of users will have vehicle data and the remaining 2 will not have vehicle data since the vehicle block has only 8 rows. Is this correct understanding?
Now another question, what happens if the company or vehicle rows are more than user rows, does those rows get ignored?
I've been trying to reply with further examples, but the system won't let me and keeps crashing out when I try.
The 3 blocks: Name, Department, and Vehicles are limited. There are 30 rows in the Name block, 10 rows in the Department block, and 10 rows in the Vehicles block. These are the maximum that can be entered for each block. I removed the blank rows for each block.
This means that a maximum of 30 names can be entered, 10 departments, and 10 vehicles. The number of each will change on each sheet, but will never exceed the maximum for each block.
In the previous example there were 5 names. This left 25 blank rows in the Names block. There were 3 departments, which left 7 blank rows in the Departments block. There were 2 vehicles, which left 8 blank rows in the Vehicles block.
Does that make sense?
