Additional Blogs by Members
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos
Have you ever wanted to take the user export file that came out of the UME and convert it into an excel file which could be manipulated.  After my last weblog I had several requests to provide a solution to do just that.  Here is what I have found.  The first step is to import your text file into Excel.  This can be done by opening Excel and selecting Data -> Importa External Data -> Import Data.  A Windows file browser box will pop up. Navigate to and select your file.  The Text Import Wizard will be displayed.  Click on next. This is step two of the text import wizard.  Make sure to check the Other box and enter "=" without the "'s in the box.  Then click the next button. Step Three will presnet itself.  Click on the finish button. The import location dialog box will present itself.  Choose where you would like to import the data.  In this case, we will use the default location. You will then have columns A and B in your worksheet.  I have added column C which increments by 8 because that is how far apart similar attributes are.  The reason for this will become clear shortly. At this point we need to manipulate the data to place in back in a format that we can use.  I typed the column headers in and then used the following formulas to transpose the columns and rows. Users =OFFSET($B$2,$C1,0) Password =OFFSET($B$3,$C1,0) Email =OFFSET($B$4,$C1,0) First Name =OFFSET($B$5,$C1,0) Last Name =OFFSET($B$6,$C1,0) Telephone =OFFSET($B$7,$C1,0) Department =OFFSET($B$8,$C1,0)  I then used the fill handle to drag these forumlas down the sheet until I had captured all of the data.
6 Comments