FG
💻 Software

Merging columns in Excel with ";" separator

Fresh5 days ago
Mar 15, 202660804 views
Confidence Score0%
0%

Problem

This is my raw data in excel in different row and cells: I would like to convert all data into this format containing 1 column and different rows: As I have large volume of data to be processed, a convenient way of converting the data is really needed.

Error Output

A   B   C   D   E   F
1   2   3   4   5   6
2   3   4   5   6   7
3   4   5   6   7   8

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Merging columns in Excel with ";" separator

Low Risk

You can use this formula to merge one row to only one column: Then, copy this formula to all rows and use the column you created where you want.

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment