Copy/import the whole row from one sheet to another, when text is populated in column

[craig811]

Hi ,

Currently I am using a Macro to import the whole row from sheet1 to sheet2 if there is text in column called 'Adjustment' in sheet1.

Instead of using a Marco could I use Power Query to do this instead?

[Anonymous · Accepted solution]

@craig811 

See example:

Shee1

Shee2

You can filter the sheet 1 to only show a single row, and then append to sheet 2. The example filters the column2 to only show column2 ="z", then append to sheet 2

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSlbSUaoAYhOlWB0EzxTOqwJiQ6XYWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t, Column3 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}, {"Column3", Int64.Type}}),
    #"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Column2] = "z")),
    #"Appended Query" = Table.Combine({#"Filtered Rows", Table})
in
    #"Appended Query"

 
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Yes. Just select your sheet 1, then select "From Table".

Once you are in the Query Editor, make a reference query from sheet 1. 

just filter your column by selecting just "Adjustments".  The formula will be:

Table.SelectRows(Sheet1, each List.Contains({"Adjustments"}, [ColumnName]))

--Nate

[AlB]

Hi @craig811 

Can you share some sample data and explain with an example based on that data, what you need?

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers