User Profile
Stephen_Kane
Copper Contributor
Joined Mar 28, 2019
User Widgets
Recent Discussions
Re: Ask the same two Choice type questions for multiple items in Forms
RobElliott Hi Rob I need to ask the same questions for a list of software titles and have the answers for each one. Your suggestion works to provide the list of titles as the first question, but to branch means the user has to select a title, then move to the next question and the next in turn. Unless I'm being obtuse, to achieve what I want I will have to create each title as a heading, then ask the two "choice" questions for each. Since I have 806 titles to survey, creating each question individually is not the best solution, which is why I want to upload the titles from a spreadsheet and then attach the two questions to each. Conceptually I want it to work like this: Software Title Usage Frequency Importance to Work Title 1 Choice Array Choice Array Title 2 Choice Array Choice Array Title 3 Choice Array Choice Array Title 4 Choice Array Choice Array Regards Stephen3.5KViews0likes2CommentsRe: Split a column by rows
Stephen_Kane Here's the sequence I think I need to follow: 1) Create a new column 2) If value in Column 1 contains an "@" symbol, cut and paste the value in Column 2 3) Remove all blank cells from Column 1 4) Remove all blank cells from Column 2 This should give me Column 1 Column 2 Username Email address Username Email address2.4KViews0likes0CommentsSplit a column by rows
Hi, All I need help in splitting a column where row 1 is a username and row 2 is an email address corresponding to that username. The data is presented in a single column as follows: Username Email address Username Email address I need to extract the email address into a second column and move it into the same row as the username. I need to automate this process , so ideally to use Power Query. Any ideas? ThanksSolved2.6KViews0likes7Comments
Recent Blog Articles
No content to show