Double Spacing

[rayrickson]

Hi there, i have a relatively simple question. I would like a set of data to be double-spaced. There are two columns of data. Here is what the data looks like now:
1 2
3 4
5 6
7 8
etc.

And here is what i want it to look like:
1
. 2
3
. 4
5
. 6
7
. 8
(I had to put a "." to get it to look right)

Thanks in advance! There are about one million rows so whatever the formula might be to convert the data might take a minute or two i guess.. I really appreciate any help

 

[sandy666]

if this is what you want use PowerQuery

source			result
Column1	Column2		Column.1	Column.2
1​	2​		1
3​	4​			2
5​	6​		3
7​	8​			4
			5
				6
			7
				8

[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(Source, {{"Column1", type text}, {"Column2", type text}}, "en-GB"),{"Column1", "Column2"},Combiner.CombineTextByDelimiter("sa", QuoteStyle.None),"Column"),
    #"Split Column by Delimiter" = Table.ExpandListColumn(Table.TransformColumns(#"Merged Columns", {{"Column", Splitter.SplitTextByDelimiter("s", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Column"),
    #"Split Column by Delimiter1" = Table.SplitColumn(#"Split Column by Delimiter", "Column", Splitter.SplitTextByDelimiter("a", QuoteStyle.Csv), {"Column.1", "Column.2"})
in
    #"Split Column by Delimiter1"[/SIZE]

 

[rayrickson]

if this is what you want use PowerQuery

source			result
[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Column1[/COLOR]	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Column2[/COLOR]		[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Column.1[/COLOR]	[COLOR=[URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFFFF]#FFFFFF[/URL] ]Column.2[/COLOR]
1​	2​		1
3​	4​			2
5​	6​		3
7​	8​			4
			5
				6
			7
				8

<tbody>
</tbody>

[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(Source, {{"Column1", type text}, {"Column2", type text}}, "en-GB"),{"Column1", "Column2"},Combiner.CombineTextByDelimiter("sa", QuoteStyle.None),"Column"),
    #"Split Column by Delimiter" = Table.ExpandListColumn(Table.TransformColumns(#"Merged Columns", {{"Column", Splitter.SplitTextByDelimiter("s", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Column"),
    #"Split Column by Delimiter1" = Table.SplitColumn(#"Split Column by Delimiter", "Column", Splitter.SplitTextByDelimiter("a", QuoteStyle.Csv), {"Column.1", "Column.2"})
in
    #"Split Column by Delimiter1"[/SIZE]

yes, exactly, thanks!

 

[sandy666]

You are welcome

Have a nice day