Answered

Merge two columns with the same data type into one column

(0) Share

Report

Posted on by Ryan_B

446

I have two lists that each have a column that is the same type of data. One list is for submissions and the other is for approved submissions. I have a gallery that shows the actual data and the submissions together, but without these being in the same column I can't sort them properly.

Example:

List 1 - Approved submissions AKA the actual data

AAA

BBB

CCC

List 2 - Submissions awaiting approval that will be added to the actual data once approved

DDD

EEE

FFF

Desired outcome:

AAA

BBB

CCC

DDD

EEE

FFF

How would I go about doing this?

Categories:

General Questions

Using Apps Using Formulas

All responses (3)

Answers (1)

jwan_gain 88 on at

Like (0)

Report

Re: Merge two columns with the same data type into one column

i have similar Problem, i hope can somebody help me: @BCBuizer
i want to merge two rows in the dataverse Table, because they have same Company Name, so when x Company had updated his Records, usually it looks two rows with same company name, but i want it to show in same row with update Records.. 😞
Ryan_B 446 on at

Like (2)

Report

Re: Merge two columns with the same data type into one column

@BCBuizer

Wow, I didn't think it would be that simple.

Turns out the reason I wasn't able to do this was because I had imported the list from Excel and the columns were showing up as field_1, field_2, etc. I remade the lists from scratch and just copy-pasted the data into them and it worked like a charm.

Thank you!
Verified answer

BCBuizer 21,973 Super User 2025 Season 1 on at

Like (1)

Report
Re: Merge two columns with the same data type into one column

Hi @Ryan_B ,

The below will work if both lists have the same column names and types:

ClearCollect(colTotal,List1); Collect(colTotal, List2)

If there's not a 100% match, you'll have to perform some manipulations.