Populating data under columns from another sheet.

[syunus26]

Hi all,

I have data extracted from backend through IT and as a result the data set columns are in different sequence(sheet 2) than the actual files (sheet 1) . I copied column headers from correct files in another tab(sheet2) . I want to populate data under columns in sheet 2 as per data in sheet 1. I cant just copy each column one after another as the data set is huge. Its very manual and repetitive task. Wanted to know if there is an easier way to do it.

Thanks in advance.

[AliGW]

Welcome to the forum.

Easiest way (copied down):

Excel 2016 (Windows) 32 bit

	A	B	C	D	E	F
1	Date	Secondary code	Match no	Trade-code	System	Amount
2	30/05/2020	1_1	11	1	ABC	1000
3	31/05/2020	1_1	11	1	ABC	2000
4	01/06/2020	3_3	22	3	EFG	3000
5	02/06/2020	4_4	11	4	EFG	4000
6	03/06/2020	5_5	23	5	EFG	5000
7	04/06/2020	6_6	24	6	HIJ	6000

Sheet: Sheet2

Excel 2016 (Windows) 32 bit

	A	B	C	D	E	F
2	=Sheet1!D2	=Sheet1!E2	=Sheet1!F2	=Sheet1!A2	=Sheet1!B2	=Sheet1!C2

Sheet: Sheet2