ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   swapping data from 2 separate columns (https://www.excelbanter.com/excel-discussion-misc-queries/71883-swapping-data-2-separate-columns.html)

Johnny D

swapping data from 2 separate columns
 
I have data in column B and data in column F. How do I swap the two columns?

Michael

swapping data from 2 separate columns
 
Hi Johnny D. Use an empty column or blank spreadsheet and copy column B to
it, say column G. Next copy column F over column B. Finally, copy column D
over column F. HTH
--
Sincerely, Michael Colvin


"Johnny D" wrote:

I have data in column B and data in column F. How do I swap the two columns?



All times are GMT +1. The time now is 12:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com