Forum Discussion
Copy Data to Other Sheets' Columns Based on Criteria
Apologies if this is answered. The search I did found similar items but not the result I'm looking for. For simplicity, let's say I have three columns. The first two are data and the third is where I would mark with an 'X' that I want that data transposed. I want all data rows with an x in that third column to be copied to another worksheet, skipping lines without the X (but not having a blank, just moving onto the next X). First page of the attachment is the data sheet. Second pageis how this would transpose correctly.
Hi Thomas,
The easiest is with Power Query - query source data, filter and land result back. Sample attached.
5 Replies
- SergeiBaklanDiamond Contributor
Hi Thomas,
The easiest is with Power Query - query source data, filter and land result back. Sample attached.
- Thomas FallonCopper Contributor
SergeiBaklan Thank you Sergei - it does not appear that if I make a change to the original table, that the queries update? (note I have kept the queries in the same Workbook, on a separate Sheet).
- SergeiBaklanDiamond Contributor
Thomas, to show update click on ribbon Data->Refresh All. Or right click on resulting table and Refresh.