wsnyder
Board Regular
- Joined
- Sep 23, 2018
- Messages
- 224
- Office Version
- 365
- Platform
- Windows
Hi all,
Using Excel 365.
Is it possible to change the order of columns in a Union or to force the Union to return the Range in the Order written?
For example,
My data is in Column Order of 3, 5, 6 but I listed the Union as 5, 6, 3 because this is how I would like the output listed
But when I paste the Range to a new sheet, the output is in the original order 3, 5, 6.
Is it possible to force the output in the order I want while using Union Method?
Thanks
-w
Using Excel 365.
Is it possible to change the order of columns in a Union or to force the Union to return the Range in the Order written?
For example,
My data is in Column Order of 3, 5, 6 but I listed the Union as 5, 6, 3 because this is how I would like the output listed
But when I paste the Range to a new sheet, the output is in the original order 3, 5, 6.
Is it possible to force the output in the order I want while using Union Method?
Thanks
-w