Hi,
I need help with transpose. My data is spread over 6 Columns. I learned to transpose one row at a time so that the data spread over 6 columns will be rearranged into 6 rows but, doing it one at a time it's time taking and more chances to make errors And every row contains one cell with - spread over different columns. I want the - to be omitted and the right cell to be shifted to the left. I know how to do it one at a time but is there any formula or tricks to do it all together at once (omit - and shift the right cell to the left)? I know it's a mess but, please help. thank you.
Bookmarks