Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-30-2023, 02:53 PM
leeuniverse leeuniverse is offline How to create 3 Columns from Data in 1 Column using every 3 Cells to create the 3 Columns? Windows 10 How to create 3 Columns from Data in 1 Column using every 3 Cells to create the 3 Columns? Office 2021
Novice
How to create 3 Columns from Data in 1 Column using every 3 Cells to create the 3 Columns?
 
Join Date: Mar 2023
Posts: 2
leeuniverse is on a distinguished road
Default How to create 3 Columns from Data in 1 Column using every 3 Cells to create the 3 Columns?

So, I have one column of data in this format...



URL
USERNAME
PASSWORD
URL
USERNAME
PASSWORD
...etc. etc.

The above repeated over and over again in one Column, and each one is its OWN Row and Cell.
I need to grab all three items creating 3 columns for each item. In other words, url, username, and password will each have its OWN column.
I need to put each group into the same columns so having...

URL / Username / Password... as Columns, putting the above data into each one.

I need a way to make this easy, cause I can manually copy and paste using "Text to Columns" for each one, But I have a few 100 Passwords I need to create which I'll die doing.
I need to do this so I can import all these passwords into a Browser as a .CSV file. My old browser 20 years of pw's doesn't and won't anytime soon have an export function. I was at least able to grab the "text" of my logins putting the info into a single column.

Please help, thank you... I have tried researching this, but I just can't find exactly what I'm needing to do. It's how I figured out how to do the above, but I need a "Formula" or whatever to make this fast.
Thanks

Last edited by leeuniverse; 03-30-2023 at 07:10 PM.
Reply With Quote
  #2  
Old 03-30-2023, 07:10 PM
leeuniverse leeuniverse is offline How to create 3 Columns from Data in 1 Column using every 3 Cells to create the 3 Columns? Windows 10 How to create 3 Columns from Data in 1 Column using every 3 Cells to create the 3 Columns? Office 2021
Novice
How to create 3 Columns from Data in 1 Column using every 3 Cells to create the 3 Columns?
 
Join Date: Mar 2023
Posts: 2
leeuniverse is on a distinguished road
Default

Thanks everyone for the input...

This initial solution ended up working and easy, on Office 2021.

Quote:
Try

=INDEX(range, SEQUENCE(rows, columns))
Where

Range is your 1 column range holding your data

Rows is the number of rows you are expecting in the output. This should simply be number of rows in your input data dividee by 3

Columns is the number of columns you require in your output. This is 3 for you.
This will end up something like

=INDEX(A2:A301, SEQUENCE(100, 3))
Note that is assumes you are using a version of Excel that includes the SEQUENCE function.

Or if you have the newest version of Excel 365

=WRAPROWS(A2:A301, 3)
Reply With Quote
  #3  
Old 03-30-2023, 11:00 PM
ArviLaanemets ArviLaanemets is offline How to create 3 Columns from Data in 1 Column using every 3 Cells to create the 3 Columns? Windows 8 How to create 3 Columns from Data in 1 Column using every 3 Cells to create the 3 Columns? Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Attached is an example how to do this in any earlier version of Excel
Attached Files
File Type: xlsx SplitColumn.xlsx (9.9 KB, 3 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create 3 Columns from Data in 1 Column using every 3 Cells to create the 3 Columns? Merge table cells across columns but skip if column don't exist jhearing Word Tables 4 05-31-2016 06:20 AM
How create non-newspaper columns? kcirbostosf Word 1 12-10-2015 10:39 PM
How to create 3 Columns from Data in 1 Column using every 3 Cells to create the 3 Columns? How to create a document with 3 columns KimC Word 3 03-28-2015 02:41 PM
How to create 3 Columns from Data in 1 Column using every 3 Cells to create the 3 Columns? How to create multiple dissimilar columns in Word? cmnielsen Word Tables 4 01-31-2015 01:45 AM
how to create two columns based on a certain criterior from the original two column? where_pc Excel 3 06-13-2011 10:39 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:59 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft