ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macros for find and replace and then joining columns (https://www.excelbanter.com/excel-discussion-misc-queries/26937-macros-find-replace-then-joining-columns.html)

BobbyCochran

Macros for find and replace and then joining columns
 
I have a large dataset where I need to do a find and replace for every group
of 3 columns. Each column as either a 1 or 0. I need to change all the "1s"
in N columns to "1", the "1s" in N+1 columns to "2", and the "1s" in N+2
columns to "3".

Then I need to merge each group of 3 columns into one column, preserving the
data. Any ideas?


All times are GMT +1. The time now is 08:22 PM.

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