I have 2 google sheets with same number of rows, but different columns; and I want to join all columns from these 2 google sheets then output into 1 sheet, need guidance on how to do that.
Hi @Jason_Lin
You can achive this with Google sheet “bulk update rows(advance )” module:
Get the datas from sheet one(Set the range of values to copy):
Aggregate the columns:
Set the range within which the data should be copied.
Best regards,
Msquare Automation
Gold Partner of Make
@Msquare_Automation
Cool…it works wonderfully! with the updated sheet (sheet 2), how do i build a flow to extract some columns from sheet2, then copy to some columns (with same column name) in sheet 3?