Merge two collections without blank spaces

[KUNGFUPANDA559]

I'm having an issue combining two collections and getting the the results i'm looking for.

Col1=HeaderValue1: TestValue1

Col2=HeaderValue2: TestValue2

Collect(FinalCollection,col1,col2)

FinalCollection yields the following results

HeaderValue1      HeaderValue2

                             TestValue2

TestValue1

When I'm looking for the following:

HeaderValue1     HeaderValue2

TestValue1           TestValue2

[v-monli-msft · Accepted solution]

Hi @KUNGFUPANDA559 ,

Try to use below formula instead:

ClearCollect(FinalCollection,Ungroup(AddColumns(col1,"Table",col2),"Table")

Regards,

Mona