![]() Check those data if they have anything abnormal. Click the cell where you want the transposed cells to. Click Kutools > Range > Transform Range, see screenshot: 3. Click the Copy button in the Clipboard group of the Home tab. I need to make a unique list on Sheet2 with values from Column A on Sheet1 but post it in one row. Select the column that you want to convert. Column A on Sheet1 has many different remarks. Also if possible, check which of your data the process stopped, just move the mouse over the variable "i" a number should appear, then go to your sheet and check the data in that row and the previous row. Click to download Kutools for Excel After installing Kutools for Excel, please do as this: 1. The shortcut to convert rows to columns or transpose columns to rows is to press Ctrl+Alt+V (Control+Command+V on the Mac), the letter e, then Enter. If you have any problems, write here which line the macro stops on and what the error message says. In Excel, if you want to move data from one column to a row or vice versa, you can use the Paste Special function. Range("E2").Resize(dic.Count, n).Value = b Im looking to transpose them to one cell d1 but want a between each name in that one cell. ![]() If dic(a(i, 1)) > n Then n = dic(a(i, 1)) Hi I have 100+ email all in a seperate cell in column D with no header. ![]() ![]() Set dic = CreateObject("Scripting.Dictionary")Ī = Range("A2:C" & Range("A" & Rows.Count).End(xlUp).Row).Value2 Dim dic As Object, i As Long, lin As Long, col As Long, n As Long
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |