I am looking for a way to merge the data from multiple files and columns into one file. I have 5 files with the same column names and want to move all the data in those columns into one column in one file. For Ex; these columns appear in each file and I need the data from these to appear in one file with the same column names. I've never done any merging of files or code writing so, I'm not sure where to go from here. Any help would be appreciated. Thanks
DATE SENT TO SOC | #DAYS WITH SOC | # Days with SOC Category | Priority | SOURCEONE DEADLINE DATE | DaysAged | NTG DAYS Age Bucket | Construction Director | TicketNumber | State |
1/18/2022 | 29 | G- < 30 DAYS OLD | 2 | 2/7/2022 | 34 | F - 30-60 DAYS OLD | JONES, ROBERT E | 4213991 | AL |
1/24/2022 | 23 | G- < 30 DAYS OLD | 2 | 2/13/2022 | 27 | G- < 30 DAYS OLD | JONES, ROBERT E | 4112369 | AL |
1/24/2022 | 23 | G- < 30 DAYS OLD | 2 | 2/13/2022 | 27 | G- < 30 DAYS OLD | JONES, ROBERT E | 4032458 | AL |