Terminé

Convert Column Text to Rows

I have a single-column listing of about 6800 companies that I need in a table format. The company records are either 7 or 8 rows long, and contain the record delimiter "|" .

I need the single column of data (68,000+ rows) converted to a table consisting of: Account Name, Industry, Revenue, Phone, URL, City, State, Zip.

The source data will be an Excel .xlsx file.

Compétences : Data Cleansing, Traitement de Données, Excel

en voir plus : how to change column to row in excel 2007, convert columns to rows in excel with formulas, convert column to comma separated list, google sheets convert column to row, how to change column headers to rows in excel, text to rows in excel, convert multiple rows to columns in excel, excel transpose column to multiple rows, convert text report file spreadsheet, excel convert column rows, excel macro export column text file, convert bitmap text file, numbers column text file java, convert hex text file, convert spanish text file english, excel convert column list rows, excel convert column multi rows, convert unix text file windows text file csharp, convert website text file, choose column text file linux

Concernant l'employeur :
( 0 commentaires ) Stamford, United States

Nº du projet : #19042934

Décerné à:

KozlouAlex

Hello. I will need more description of which data is missed in 7 rows columns and can complete this task during 30 minutes

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 0 jours
(9 Commentaires)
3.6

28 freelance font une offre moyenne de $25 pour ce travail

mirniyazuddin92

Hi there, I can convert column text to rows, horizontal columns to vertical rows. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(306 Commentaires)
7.7
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please send me a message so that we can discuss more.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(284 Commentaires)
7.2
saqibmunir55

send me complete file i will convert data into colmns send me complete file i will convert data into colmns

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(490 Commentaires)
7.2
BithiXpert

Hello Dear, I am an expert in Data Cleansing, Data Processing, Excel and I am really interested in your project. I am available to start working on it now. I work efficiently and will finish in a timely manner and wil Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(224 Commentaires)
7.0
TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(300 Commentaires)
6.7
bilalmaher053

hey, i see ur file and i can do this right now, thanks...

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(163 Commentaires)
6.3
rohitagarberg

hi sir, i will convert the 68k rows of data in a single column to multiple column with the fields of each entry in a single row divided in appropriate columns, ready to start now and will complete in few hours for 15$, Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(300 Commentaires)
6.4
emamulbd

Good Day, I am willing to take responsibility for your project too! Please let me know, if you want my services. Thanks Emamul H.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(59 Commentaires)
5.9
masud0012

I am ready to start right now.I am a full time dedicated freelancer. Dear Hiring Manager, I have read your job description carefully and I’m very considering your job such as these capabilities. I have fantastic expe Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(120 Commentaires)
6.1
bilalsafdar111

yes sure, i can convert Column Text to Rows. can you provide detail and will start right now. thanks...............................! Bilal

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(58 Commentaires)
5.5
branislavm

Hello! I am thinking to import data into the database and write a query to export data in the desired format. Could you provide your file, please? Regards, Branislav Mihaljev

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(21 Commentaires)
5.2
parsermonster

Hi there, This example file appears to be a simple unstacking process. It would be a piece of cake if each company were exactly 7 or 8 rows. With that extra wrinkle, please allow a little more time for me to process Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(14 Commentaires)
4.8
brashel

Hello sir, I am expert in excel and able to decorate your data as you want. So, please contact with me. Thanks a lot.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(31 Commentaires)
4.4
webanis

Hi, I am interested in your offer Let me know more details about this work. I will start working immediately Br;

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(19 Commentaires)
4.0
Rina247

I have a team. My team is always active for work. If you give me a chance and give direction for the job, I will do this. Regard's Blood Freelancer Team

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(14 Commentaires)
3.8
Masudhasan008

i have checked your attached excel file and understand the project. let's talk more about the project in chat and if you want i can also do some sample work for you.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(9 Commentaires)
4.1
rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit my Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(18 Commentaires)
4.0
haleem0786

i can do this. i have good command over ms excel especially pivot table, charts, advance formulas, formatting, macro, VBA etc. Please review my profile and inbox [login to view URL]

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(16 Commentaires)
3.6
Devotion20

Hi there! Convert single column list to Rows of 7-8 fields. I am Bhakti from India. I am interested to work on your project. I have checked and understood attached sample file. Hope you will contact me. Thank you : Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(6 Commentaires)
3.5
UnityGame

Hi, there. Nice to meet you. I have been a talented C# developer for several years. I started programming since 12 so I am sure I can complete your task in 2~3 hours. Please contact me.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(7 Commentaires)
3.7