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.
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
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
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 will provide high quality work. I have great researching skills and would gladly work on your project. I am waiting to your quick positive reply and if you have any questions, feel free to ask me.
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$, thanks
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 experience in this fields such as Data Entry, MS Excel and other related tasks. I am full time dedicated freelancer. I have 3 years+ experience in these categories.
I believe my capabilities would be ideal for you. I can complete this job within the necessary period.
You can get hold of me instantly to discuss this position further.
I am waiting for your kind respond.
I am ready to start right now.
Thanks.
Best Regards,
Masud
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
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 myself for this project. please contact with me.
Thanks.
Hello there! I will be highly delightful if you provide me chance to work on your assignment and I will assure you high quality document in all aspects within your deadline. Open to further discussion over direct message in chat box
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
Sir, I will take a couple hours to do this job. I have Ten years Experience from a reputation IT firm. I am detail oriented hard worker and honest. I assure that I will provide you Quality Work with 100% accuracy. My main goal is your satisfaction. If i get this chance to help you, I will do all of my best. Thanks !
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.
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 :)