Hi Everyone,
I have an excel spreadsheet in which I have inserted a reference column (A) and would like to horizontally align column B through column D, inserting empty rows as needed. In this example, 112 in the Number column would be moved down one row. This one has really stumped me. Can an Excel genius who sees this help? Thanks!
Here's an example:
REF Number Category Class
111 112 B D
112 113 A C
113 114 C B
114 123 B B
121 131 F O
122 133 G Y
123 221 C C
131 231 E U
132 212 A C
133 221 R T
Bookmarks