Hi need help combining columns into a row as follow in the data studio & google sheet
| Account | Accocunt | Sale | Sale |
|---|---|---|---|
| A1 | A2 | 11 | 12 |
INTO THIS ->
| Account | Accocunt |
|---|---|
| A1 | 11 |
| A2 | 12 |
CodePudding user response：
Would a formula like this help?
={FLATTEN({A2:A100,C2:C100}),FLATTEN({B2:B100,D2:D100})}
CodePudding user response：
try:
={FLATTEN(A2:B100), FLATTEN(C2:D100)}